package com.yuzhi.master.drainCorrelation.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.yuzhi.common.core.mapper.BaseMapperPlus;
import com.yuzhi.master.drainCorrelation.domain.DrainCorrelation;
import com.yuzhi.master.drainCorrelation.domain.vo.DrainCorrelationVo;
import org.apache.ibatis.annotations.Param;

/**
 * 排水系统关联表Mapper接口
 *
 * @author auto code generator
 * @date 2025-08-13
 */
public interface DrainCorrelationMapper extends BaseMapperPlus<DrainCorrelationMapper, DrainCorrelation, DrainCorrelationVo> {

    /**
     * 分页查询排水系统关联表
     */
    Page<DrainCorrelationVo> selectPageList(@Param("page") Page<DrainCorrelationVo> page, @Param(Constants.WRAPPER) Wrapper<DrainCorrelation> queryWrapper);

    /**
     * 根据测站ID查询关联信息
     */
    DrainCorrelationVo selectByStcd(@Param("stcd") String stcd);

    /**
     * 根据管道ID查询关联信息
     */
    DrainCorrelationVo selectByDraiPipeId(@Param("draiPipeId") String draiPipeId);

    /**
     * 根据管井ID查询关联信息
     */
    DrainCorrelationVo selectByManholeId(@Param("manholeId") String manholeId);
}
